package com.example.front.test;

import java.util.stream.Stream;

/**
 * Label
 *
 * @author liming2
 * @date 2023/10/24 14:35
 */
public class Label {
    public static void main(String[] args) {
        String[] sss = ss.split("\n");
        System.out.println(sss.length);
        System.out.println(Stream.of(sss).distinct().count());
        Stream.of(sss).distinct().forEach(s -> {
            String[] r = s.split("\t");
            System.out.printf("INSERT INTO `phoenix_firm_label` (`firm_id`, `label`) VALUES (%s, '%s');\n", r[0], r[1]);
        });
    }

    static String ss = "371\t长期不开车\n" +
            "658\t长期不开车\n" +
            "1512\t长期不开车\n" +
            "1512\t党员先锋车队\n" +
            "1548\t长期不开车\n" +
            "1543\t长期不开车\n" +
            "1543\t星级车队\n" +
            "402\t长期不开车\n" +
            "398\t长期不开车\n" +
            "1031\t长期不开车\n" +
            "636\t长期不开车\n" +
            "648\t长期不开车\n" +
            "936\t长期不开车\n" +
            "670\t长期不开车\n" +
            "1545\t长期不开车\n" +
            "325\t长期不开车\n" +
            "1530\t长期不开车\n" +
            "1023\t长期不开车\n" +
            "1544\t长期不开车\n" +
            "363\t长期不开车\n" +
            "1615\t长期不开车\n" +
            "660\t长期不开车\n" +
            "326\t长期不开车\n" +
            "323\t长期不开车\n" +
            "1549\t长期不开车\n" +
            "55\t长期不开车\n" +
            "934\t长期不开车\n" +
            "653\t长期不开车\n" +
            "651\t长期不开车\n" +
            "641\t长期不开车\n" +
            "640\t长期不开车\n" +
            "1546\t长期不开车\n" +
            "1550\t长期不开车\n" +
            "675\t长期不开车\n" +
            "635\t长期不开车\n" +
            "1506\t长期不开车\n" +
            "1610\t长期不开车\n" +
            "1068\t长期不开车\n" +
            "1068\t党员先锋车队\n" +
            "1068\t星级车队\n" +
            "1071\t党员先锋车队\n" +
            "1071\t泉城的士\n" +
            "1071\t巾帼车队\n" +
            "1071\t星级车队\n" +
            "1081\t长期不开车\n" +
            "1328\t长期不开车\n" +
            "1328\t星级车队\n" +
            "1328\tKOL\n" +
            "1482\t星级车队\n" +
            "1585\t党员先锋车队\n" +
            "1585\t长期不开车\n" +
            "1627\t长期不开车\n" +
            "45\t长期不开车\n" +
            "146\t党员先锋车队\n" +
            "146\t泉城的士\n" +
            "146\t巾帼车队\n" +
            "146\t星级车队\n" +
            "193\t党员先锋车队\n" +
            "193\t泉城的士\n" +
            "193\t星级车队\n" +
            "194\t星级车队\n" +
            "194\t泉城的士\n" +
            "194\t党员先锋车队\n" +
            "286\t星级车队\n" +
            "286\t巾帼车队\n" +
            "286\t泉城的士\n" +
            "325\t长期不开车\n" +
            "336\t巾帼车队\n" +
            "336\t泉城的士\n" +
            "431\t党员先锋车队\n" +
            "431\t星级车队\n" +
            "473\t星级车队\n" +
            "473\t泉城的士\n" +
            "473\t党员先锋车队\n" +
            "473\t巾帼车队\n" +
            "474\t星级车队\n" +
            "474\t党员先锋车队\n" +
            "474\t泉城的士\n" +
            "565\t泉城的士\n" +
            "565\t星级车队\n" +
            "565\t党员先锋车队\n" +
            "571\t巾帼车队\n" +
            "571\t泉城的士\n" +
            "571\t党员先锋车队\n" +
            "571\t星级车队\n" +
            "572\t泉城的士\n" +
            "572\t星级车队\n" +
            "573\t星级车队\n" +
            "573\t泉城的士\n" +
            "573\t巾帼车队\n" +
            "598\t党员先锋车队\n" +
            "598\t星级车队\n" +
            "601\t党员先锋车队\n" +
            "604\t泉城的士\n" +
            "604\t党员先锋车队\n" +
            "612\t星级车队\n" +
            "955\t党员先锋车队\n" +
            "955\t星级车队\n" +
            "956\t星级车队\n" +
            "956\t党员先锋车队\n" +
            "956\t泉城的士\n" +
            "957\t泉城的士\n" +
            "957\t巾帼车队\n" +
            "957\t星级车队\n" +
            "961\t党员先锋车队\n" +
            "961\t泉城的士\n" +
            "961\t巾帼车队\n" +
            "961\t星级车队\n" +
            "962\t党员先锋车队\n" +
            "962\t泉城的士\n" +
            "962\t巾帼车队\n" +
            "962\t星级车队\n" +
            "965\t泉城的士\n" +
            "965\t星级车队\n" +
            "965\t巾帼车队\n" +
            "966\t泉城的士\n" +
            "966\t巾帼车队\n" +
            "966\t党员先锋车队\n" +
            "966\t星级车队\n" +
            "968\t党员先锋车队\n" +
            "971\t星级车队\n" +
            "1104\t党员先锋车队\n" +
            "1104\t星级车队\n" +
            "1227\t长期不开车\n" +
            "1239\t星级车队\n" +
            "1277\t泉城的士\n" +
            "1278\t星级车队\n" +
            "1278\t党员先锋车队\n" +
            "1278\t泉城的士\n" +
            "1278\t巾帼车队\n" +
            "1283\t长期不开车\n" +
            "1319\t星级车队\n" +
            "1499\t星级车队\n" +
            "1500\t星级车队\n" +
            "1512\t长期不开车\n" +
            "1512\t党员先锋车队\n" +
            "1513\t星级车队\n" +
            "1514\t星级车队\n" +
            "1515\t星级车队\n" +
            "1516\t星级车队\n" +
            "1517\t星级车队\n" +
            "1520\t星级车队\n" +
            "1523\t星级车队\n" +
            "1524\t星级车队\n" +
            "1527\t星级车队\n" +
            "1531\t泉城的士\n" +
            "1531\t党员先锋车队\n" +
            "1531\t星级车队\n" +
            "1531\t巾帼车队\n" +
            "1533\t泉城的士\n" +
            "1535\t星级车队\n" +
            "1543\t星级车队\n" +
            "1545\t长期不开车\n" +
            "1553\t星级车队\n" +
            "1556\t星级车队\n" +
            "1557\t星级车队\n" +
            "1558\t星级车队\n" +
            "1561\t星级车队\n" +
            "1563\t星级车队\n" +
            "1564\t星级车队\n" +
            "1566\t星级车队\n" +
            "1567\t星级车队\n" +
            "1568\t星级车队\n" +
            "1569\t星级车队\n" +
            "1583\t党员先锋车队\n" +
            "1591\t星级车队\n" +
            "1592\t星级车队\n" +
            "1656\t长期不开车\n";
}
